//===========================================================================================================================
// Cuberry - http://www.cuberry.net
// Copyright (c) 2012
// by Peacequare® - Amir Moussa
//===========================================================================================================================
// This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License 
// as published by the Free Software Foundation, either version 3 of the License, or any later version.
//
// Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated 
// documentation files (the "Software"), to deal in the Software without restriction, including without limitation 
// the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and 
// to permit persons to whom the Software is furnished to do so, subject to the following conditions:
//
// The above copyright notice and this permission notice shall be included in all copies or substantial portions 
// of the Software.
//
// This program is distributed in the hope that it will be useful.
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED 
// TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL 
// THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF 
// CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER 
// DEALINGS IN THE SOFTWARE.
//
// See the GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program.  If not, see <http://www.gnu.org/licenses/>.
//===========================================================================================================================

using System.Collections.ObjectModel;
using System.Linq;
using P2.Cuberry.Framework.Helper.Configuration;
using P2.Cuberry.Framework.Helper;


namespace P2.Cuberry.Modules.Clinicom.BedList.Services
{
    public class BedListService : IBedListService
    {
        public ObservableCollection<BusinessEntities.BedList> RetrieveBedLists()
        {
            ObservableCollection<BusinessEntities.BedList> cbBedLists = new ObservableCollection<BusinessEntities.BedList>();
            string connectionString = ConfigurationSetUp.GetEntConnectionString("Clinicom", Properties.Settings.Default.EntityResources);

            using (DAL.BedListDataContext db = new DAL.BedListDataContext(connectionString))
            {
                var xItems = from xItem in db.BedList
                            //orderby xItem.DateOfBirth descending
                            select xItem;
                foreach (var xItemx in xItems)
                    cbBedLists.Add(new BusinessEntities.BedList(xItemx));
            }
            return cbBedLists;
        }

        //Find++
        public ObservableCollection<BusinessEntities.BedList> RetrieveBedLists(BusinessEntities.BedList templateEntity)
        {
            try
            {
                ObservableCollection<BusinessEntities.BedList> cbBedLists = new ObservableCollection<BusinessEntities.BedList>();
                string connectionString = ConfigurationSetUp.GetEntConnectionString("Clinicom", Properties.Settings.Default.EntityResources);
                using (DAL.BedListDataContext db = new DAL.BedListDataContext(connectionString))
                {
                    IQueryable<DAL.BedList> query = db.BedList;
                    
                                        if (!string.IsNullOrEmpty(templateEntity.Room)) 
                        query = query.Where(t => t.Room.Contains(templateEntity.Room)); 
                    if (!string.IsNullOrEmpty(templateEntity.Status)) 
                        query = query.Where(t => t.Status.Contains(templateEntity.Status)); 
                    if (!string.IsNullOrEmpty(templateEntity.Category)) 
                        query = query.Where(t => t.Category.Contains(templateEntity.Category)); 
                    //if (!string.IsNullOrEmpty(templateEntity.AccountNr)) 
                    //    query = query.Where(t => t.AccountNr.Contains(templateEntity.AccountNr)); 
                    //if (!string.IsNullOrEmpty(templateEntity.Companion)) 
                    //    query = query.Where(t => t.Companion.Contains(templateEntity.Companion)); 

                    

                    if (templateEntity.StatusID > -1) 
                        query = query.Where(t => t.StatusID == templateEntity.StatusID);
                    //** query = query.OrderByDescending(t => t.DocumentDate); //.ThenBy(a => a.SortingPosition).ThenBy(a => a.FiAccountNameEn);

                    var xItems = from xItem in query 
                                  select xItem;

                    foreach (var xItem in xItems)
                        cbBedLists.Add(new BusinessEntities.BedList(xItem));
                }

                return cbBedLists;
            }
            catch (System.Exception ex)
            {
                P2ExceptionHandler.LogException(ex, string.Format("{0}.{1}", this.GetType().Name, System.Reflection.MethodInfo.GetCurrentMethod().Name));
                return null;
            }
        }
                                
        
    }
}